package com.qf.mapper;/*
 *徐韬
 *2021/10/29
 *20:23
 */

import com.qf.pojo.TSmsTemplate;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface smstempMapper {
    @Insert("insert into t_sms_template values(0,#{template},#{paramter},#{owntype},#{creater},#{status})")
    int addsms(TSmsTemplate tSmsTemplate);
    @Select("select * from t_sms_template ")
    List<TSmsTemplate> finAll();
    int update(TSmsTemplate tSmsTemplate);
    @Select("select * from t_sms_template where id = #{id}")
    TSmsTemplate selectById(Long id);
    int deleteByids(@Param("ids")List<Integer> ids);
    int deleteByidsandcreater(@Param("ids") List<Integer> ids,@Param("creater") Long creater);
    List<TSmsTemplate> showAllByparams(TSmsTemplate tSmsTemplate);
}
